StudywithDemo

How to Fix Binary logging Error in MySQL

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
While executing the show binary logs command i got one error message “Error Code: 1381. You are not using binary logging”. To fix this you can simply add the “log-bin=mysql-bin” text in your my.ini file. But the main problem is finding the location of my.ini configuration file ”. I searched a lot but found different solutions due to this i totally confused. Finally did some analysis and fixed the error. I checked my solution in my pc(Windows 7), laptop(Win 8)worked fine. So that i decided to share with you along with video demo. This is the exact solution those who are getting this issue. Just by following the below procedure you can easily fix it.</div>
<div style="text-align: justify;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOvmXeD4gvNmpuD6haB4NDF13clUIJ7k1driFAjsypon7K0x84hC3hixC6la_O7eByIOLQw5tv9q9btNrQIy4O6pch8JAeeEeXlEifHAE4Tno26sD9gpLEz-EFUm9nA8DpyiavClsYEp4/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOvmXeD4gvNmpuD6haB4NDF13clUIJ7k1driFAjsypon7K0x84hC3hixC6la_O7eByIOLQw5tv9q9btNrQIy4O6pch8JAeeEeXlEifHAE4Tno26sD9gpLEz-EFUm9nA8DpyiavClsYEp4/s1600/1.jpg" width="640"></a></div>
</div>

How to Fix Binary logging Error in MySQL

While executing the show binary logs command i got one error message “Error Code: 1381. You are not using binary logging”. To fix this you...

Data Export and Import using MySQL Workbench

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
MySQL Workbench is a visual database designing tool that integrates sql administration, sql development and database modeling. It is available on windows, Linux and mac os that means you can use MySQL document work on any of this platform and can use this unified integrated development environment for your MySQL database system. You can download MySQL workbench for free from the URL “<span style="color: #0b5394;">https://www.mysqlcom/products/workbench</span>”. MySQL workbench installation pretty straight forward.<br>
<br>
In MySQL Workbench under navigator session we have two important things 
1. Data export 2. Data import. I will explain in detail with the help of
 screenshots.</div>
<div style="text-align: justify;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9LQ1THoer8xcTJ8n8HGDMPYfbjjTsCShKhlbk6IstAREsARGFc8KJXFO4UgPsxlRhuutACvXcKkXeqoLEGo56IIZD-GMJqMcbjBc-mEwpMTBQEl5qwnbMb0yPdJvO47KyQwCgb0MB_tw/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9LQ1THoer8xcTJ8n8HGDMPYfbjjTsCShKhlbk6IstAREsARGFc8KJXFO4UgPsxlRhuutACvXcKkXeqoLEGo56IIZD-GMJqMcbjBc-mEwpMTBQEl5qwnbMb0yPdJvO47KyQwCgb0MB_tw/s1600/8.png" width="640"></a></div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
<br>
</div></div>

Data Export and Import using MySQL Workbench

MySQL Workbench is a visual database designing tool that integrates sql administration, sql development and database modeling. It is avail...

Backup and Restore MySQL Database using Command Prompt

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
In this article i have covered two modules Backup with mysqldump command and Restore with mysql command. Database concepts are considered as dry subject. I promised to make backup and recovery subject as interesting as possible it is very useful whenever developer or any user accidently drop database table and don’t have any backup, they want to audit database which existed quite a while ago. Sometime they have a backup and they don’t know how to restore it and something bad happens like disaster and they do not have data or any database backup. In addition to that human errors are going to be there always. So that am going to tell how to take efficient backup and recovery your database by restoring it to its original state.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJjFnns12cJ4eWiTUFIpY0G4Ua9V7EgjySfuKCpercu3orBA4sOoiDV-HjWv0UZx2piWqRpPXxSrxWmkqKfNdIloNMXw2TpfkQisccNEanGixO9mKaviOSU0Ojiy2d2XPw_qav4AUR4mg/s1600/success-failure-arrow-opposite-directions-pencil-vector-32219664+copy.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Backup with mysqldump command and Restore with mysql command" border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJjFnns12cJ4eWiTUFIpY0G4Ua9V7EgjySfuKCpercu3orBA4sOoiDV-HjWv0UZx2piWqRpPXxSrxWmkqKfNdIloNMXw2TpfkQisccNEanGixO9mKaviOSU0Ojiy2d2XPw_qav4AUR4mg/s1600/success-failure-arrow-opposite-directions-pencil-vector-32219664+copy.png" title="" width="374"></a></div>
</div>

Backup and Restore MySQL Database using Command Prompt

In this article i have covered two modules Backup with mysqldump command and Restore with mysql command. Database concepts are considered ...

Installing Cassandra on Windows

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
In
this tutorial you will learn how to install cassandra database and Cqlsh on
windows xp/vista/7/8. I face some problems when iam installing cassandra on my
windows machine so i decided to share my experience and some important
information to install cassandra. I think it will more usefull to those who
want to install the cassandra database. Please follow the below steps carefully.</div>
<div class="MsoNormal" style="text-align: justify;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfypPCzWcp0WP7gToj3n8u-BZmxwngMvYxjf_JBYTYIJLaRgXurAX5YE6G2Y9BHlGW1UmRWWkFbhvicDnVJwFltO4fQnutVPGuEqoapAXF808ijzOKDq1Vk7hNx5f3_McUpuH4X4eWFeg/s1600/studywithdemo.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfypPCzWcp0WP7gToj3n8u-BZmxwngMvYxjf_JBYTYIJLaRgXurAX5YE6G2Y9BHlGW1UmRWWkFbhvicDnVJwFltO4fQnutVPGuEqoapAXF808ijzOKDq1Vk7hNx5f3_McUpuH4X4eWFeg/s1600/studywithdemo.png" width="400"></a></div>
</div>

Installing Cassandra on Windows

In this tutorial you will learn how to install cassandra database and Cqlsh on windows xp/vista/7/8. I face some problems when iam install...